This function will allow you to update and even add records to this database from an external source. By update we mean the ability to change your fees and other fields from an external FileMaker Pro database (the absolute recommended method) or an external "tab-delimted" text field. You must be totally familiar with how to import records using FileMaker Pro. Try experimenting with your own databases and consult a FileMaker Pro book.

Fixing any problems encountered during your importing/updating are not covered by technical support. You should backup your software before you proceed. You must also fully understand how to restore the Procedures module if you really mess things up!!!

The Fields you can import into
To assist you in importing/updating data, the table below tells you the field name, its data type and function. Fields not mentioned should not be updated by you!

Field Name(abc order)	Field Type	Properties of the field
AutoRef	text	Value of "Yes" mean create a letter when used
CDT	text	ADA procedure code
Code	text	The unique code for this record
Commission	text	Value of "Yes" if item used for commissions
Cost	number	cost of product, include approx S&H
Days_POV	number	number of days in post-op period
DeleteFlag  (new field)	number	a value of 1 means delete in batch
Description	text	Brief procedure description
Discountable	text	If item can be discounted = "Yes"
Fee10	number	fee schedule 10 $$
Fee11	number	fee schedule 11 $$
Fee12	number	fee schedule 12 $$
Fee13	number	fee schedule 13 $$
Fee14	number	fee schedule 14 $$
Fee15	number	fee schedule 15 $$
Fee1A	number	fee schedule 1A $$ - what patients pay!!!
Fee2H	number	fee schedule 2H $$ - what HMOs pay!!!
Fee3M	number	fee schedule 3M $$ - what Medicare pay!!!
Fee4P	number	fee schedule 4P $$ - what private insur's pay!!!
Fee5	number	fee schedule 5 $$
Fee6	number	fee schedule 6 $$
Fee7	number	fee schedule 7 $$
Fee8	number	fee schedule 8 $$
Fee9	number	fee schedule 9 $$
HA0Message	text	narrative record sent to insurance carrier via ECS
Match_Price	number
Modifier	text	default modifier 1
Modifier2	text	default modifier 2
Notes	text	free notes
Plan_Price	number
Purch_Service	text	if purchased enter "Yes"
RVU	number	relative value units
Vendor	text	code of product's vendor
SKU	text	UPC or SKU
TOS	text	Type of Service
UPIN	text	Enter "Yes" if UPIN required with Medicare

Getting Startup with Update
Select "UPDATE from external file" from the Scripts menu selection located across the top of the current window. If you do not have administrator privileges, you will need to enter the password before continuing.

Once you have entered the password and read the confirmation dialog, you will get one of the Open File Dialogs below. Make sure that Show: All Available is selected, otherwise your non-FileMaker Pro file will not bee seen. The file you want to import from should be placed into the PracticeMaker5 folder on your computer, or any place elsewhere you can easily find it. Select the file you want (here it is 2004 Medicare Fees, a FileMaker database...the best way to go!!!). The click Open.



Once you have selected your file, you will get the Import Field Mapping dialog below. You must match up all field, but especially you must line up the "key field" Code in the source file (the left side of the dialog), and the destination (right side...Procedures.fp5). Once the alignment of fields is done, and the Import Action settings exactly match what is shown below, click Import.